Overview

Dataset info

Number of variables29
Number of observations35208
Missing cells0 (0.0%)
Duplicate rows0 (0.0%)
Total size in memory29.6 MiB
Average record size in memory881.3 B

Variables types

CAT15
NUM9
DATE3
BOOL2

Reproduction info

Date of analysis2020-02-20 22:01:50.515896
Versionpandas-profiling v2.4.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download Configurationconfig.yaml

Warnings

CI_Name_aff has a high cardinality: 2495 distinct values Warning
CI_Name_CBy has a high cardinality: 3279 distinct values Warning
CI_TypeSubType_aff has a high cardinality: 71 distinct values Warning
CI_TypeSubType_CBy has a high cardinality: 72 distinct values Warning
Count_Reassignments has 21906 (62.2%) zeros Zeros
Count_Related_Changes has 34732 (98.6%) zeros Zeros
Count_Related_Incidents is highly skewed (γ1 = 50.43666887) Skewed
Count_Related_Incidents has 34164 (97.0%) zeros Zeros
Count_Related_Interactions is highly skewed (γ1 = 37.81452834) Skewed
KM_number has a high cardinality: 1542 distinct values Warning
Service_Component_WBS_aff has a high cardinality: 260 distinct values Warning
ServiceComp_WBS_CBy has a high cardinality: 263 distinct values Warning
Resolved_Time_HourOfDay is highly correlated with Close_Time_HourOfDayHigh Correlation
Close_Time_HourOfDay is highly correlated with Resolved_Time_HourOfDayHigh Correlation
Resolved_Time_DayOfWeek is highly correlated with Close_Time_DayOfWeekHigh Correlation
Close_Time_DayOfWeek is highly correlated with Resolved_Time_DayOfWeekHigh Correlation
ResolvedShift is highly correlated with CloseShiftHigh Correlation
CloseShift is highly correlated with ResolvedShiftHigh Correlation
Resolved_Time_DayOfWeek is highly correlated with Close_Time_DayOfWeekHigh Correlation
Close_Time_DayOfWeek is highly correlated with Resolved_Time_DayOfWeekHigh Correlation

Variables

CI_Name_aff
Categorical

HIGH CARDINALITY
Distinct count2495
Unique (%)7.1%
Missing0
Missing (%)0.0%
Memory size275.2 KiB
SUB000456
 
2988
SBA000462
 
1653
WBA000058
 
1571
SBA000607
 
1353
WBA000133
 
1287
Other values (2490)
26356
ValueCountFrequency (%) 
SUB000456 2988 8.5%
 
SBA000462 1653 4.7%
 
WBA000058 1571 4.5%
 
SBA000607 1353 3.8%
 
WBA000133 1287 3.7%
 
WBA000011 898 2.6%
 
WBA000144 886 2.5%
 
DTA000616 777 2.2%
 
SUB000424 722 2.1%
 
WBA000103 470 1.3%
 
Other values (2485) 22603 64.2%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length9
Mean length8.995540786
Min length8
Scatter

CI_Name_CBy
Categorical

HIGH CARDINALITY
Distinct count3279
Unique (%)9.3%
Missing0
Missing (%)0.0%
Memory size275.2 KiB
SUB000456
 
2902
SBA000462
 
1638
WBA000058
 
1572
SSW000101
 
1322
WBA000133
 
1268
Other values (3274)
26506
ValueCountFrequency (%) 
SUB000456 2902 8.2%
 
SBA000462 1638 4.7%
 
WBA000058 1572 4.5%
 
SSW000101 1322 3.8%
 
WBA000133 1268 3.6%
 
SBA000607 1241 3.5%
 
WBA000144 909 2.6%
 
WBA000011 866 2.5%
 
DTA000616 804 2.3%
 
SUB000424 707 2.0%
 
Other values (3269) 21979 62.4%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length9
Mean length8.93728698
Min length4
Scatter

CI_TypeSubType_aff
Categorical

HIGH CARDINALITY
Distinct count71
Unique (%)0.2%
Missing0
Missing (%)0.0%
Memory size275.2 KiB
application-Server Based Application
11321
application-Web Based Application
7966
subapplication-Web Based Application
6016
application-Desktop Application
3294
computer-Laptop
 
1818
Other values (66)
4793
ValueCountFrequency (%) 
application-Server Based Application 11321 32.2%
 
application-Web Based Application 7966 22.6%
 
subapplication-Web Based Application 6016 17.1%
 
application-Desktop Application 3294 9.4%
 
computer-Laptop 1818 5.2%
 
application-Citrix 602 1.7%
 
storage-SAN 449 1.3%
 
application-Client Based Application 405 1.2%
 
subapplication-Server Based Application 397 1.1%
 
computer-Desktop 397 1.1%
 
Other values (61) 2543 7.2%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length40
Mean length31.9677062
Min length11
Scatter

CI_TypeSubType_CBy
Categorical

HIGH CARDINALITY
Distinct count72
Unique (%)0.2%
Missing0
Missing (%)0.0%
Memory size275.2 KiB
application-Server Based Application
10349
application-Web Based Application
7741
subapplication-Web Based Application
5746
application-Desktop Application
2825
computer-Laptop
 
1809
Other values (67)
6738
ValueCountFrequency (%) 
application-Server Based Application 10349 29.4%
 
application-Web Based Application 7741 22.0%
 
subapplication-Web Based Application 5746 16.3%
 
application-Desktop Application 2825 8.0%
 
computer-Laptop 1809 5.1%
 
software-System Software 1428 4.1%
 
storage-SAN 576 1.6%
 
application-Citrix 496 1.4%
 
subapplication-Server Based Application 468 1.3%
 
computer-Desktop 467 1.3%
 
Other values (62) 3303 9.4%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length40
Mean length31.23761645
Min length9
Scatter
Distinct count35070
Unique (%)99.6%
Missing0
Missing (%)0.0%
Memory size275.2 KiB
Minimum2013-10-01 08:29:26
Maximum2014-03-31 22:47:32
Mini histogram
Histogram
Histogram

Close_Time_DayOfWeek
Categorical

HIGH CORRELATION
HIGH CORRELATION
Distinct count7
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size275.2 KiB
Tuesday
7588
Monday
7291
Thursday
6945
Wednesday
6660
Friday
6574
Other values (2)
 
150
ValueCountFrequency (%) 
Tuesday 7588 21.6%
 
Monday 7291 20.7%
 
Thursday 6945 19.7%
 
Wednesday 6660 18.9%
 
Friday 6574 18.7%
 
Saturday 92 0.3%
 
Sunday 58 0.2%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length9
Mean length7.182742559
Min length6
Scatter

Close_Time_HourOfDay
Real number (ℝ≥0)

HIGH CORRELATION
Distinct count23
Unique (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean12.33640082
Minimum0
Maximum23
Zeros8
Zeros (%)< 0.1%
Memory size275.2 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile8
Q110
median12
Q315
95-th percentile16
Maximum23
Range23
Interquartile range (IQR)5

Descriptive statistics

Standard deviation2.826838358
Coefficient of variation (CV)0.229146118
Kurtosis-0.6053253072
Mean12.33640082
Median Absolute Deviation (MAD)2.413676665
Skewness-0.01308887786
Sum434340
Variance7.991015102
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 4.5 5.5 6.5 ... 16.5 17.5 18.5 21.5 23. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
14 4402 12.5%
 
15 4373 12.4%
 
11 3959 11.2%
 
10 3795 10.8%
 
13 3791 10.8%
 
16 3451 9.8%
 
9 3214 9.1%
 
12 3098 8.8%
 
8 2605 7.4%
 
17 1169 3.3%
 
Other values (13) 1351 3.8%
 
ValueCountFrequency (%) 
0 8 < 0.1%
 
1 5 < 0.1%
 
3 2 < 0.1%
 
4 1 < 0.1%
 
5 15 < 0.1%
 
ValueCountFrequency (%) 
23 7 < 0.1%
 
22 34 0.1%
 
21 86 0.2%
 
20 53 0.2%
 
19 63 0.2%
 

CloseShift
Categorical

HIGH CORRELATION
Distinct count3
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size34.6 KiB
Day
30083
Night
 
3548
Evening
 
1577
ValueCountFrequency (%) 
Day 30083 85.4%
 
Night 3548 10.1%
 
Evening 1577 4.5%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length7
Mean length3.38070893
Min length3
Scatter

Closure_Code
Categorical

Distinct count10
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size275.2 KiB
Software
11817
Other
10545
Hardware
2879
User error
2686
No error - works as designed
2379
Other values (5)
4902
ValueCountFrequency (%) 
Software 11817 33.6%
 
Other 10545 30.0%
 
Hardware 2879 8.2%
 
User error 2686 7.6%
 
No error - works as designed 2379 6.8%
 
Data 1494 4.2%
 
Operator error 1360 3.9%
 
Unknown 1290 3.7%
 
User manual not used 634 1.8%
 
Referred 124 0.4%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length28
Mean length8.846938196
Min length4
Scatter

Count_Reassignments
Real number (ℝ≥0)

ZEROS
Distinct count32
Unique (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.9855146558
Minimum0
Maximum36
Zeros21906
Zeros (%)62.2%
Memory size275.2 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q31
95-th percentile5
Maximum36
Range36
Interquartile range (IQR)1

Descriptive statistics

Standard deviation2.033034565
Coefficient of variation (CV)2.062916622
Kurtosis32.74810183
Mean0.9855146558
Median Absolute Deviation (MAD)1.226351059
Skewness4.427700223
Sum34698
Variance4.133229542
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 11.5 15.5 17.5 25.5 36. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 21906 62.2%
 
1 5679 16.1%
 
2 3225 9.2%
 
3 1640 4.7%
 
4 969 2.8%
 
5 550 1.6%
 
6 373 1.1%
 
7 242 0.7%
 
8 160 0.5%
 
9 117 0.3%
 
Other values (22) 347 1.0%
 
ValueCountFrequency (%) 
0 21906 62.2%
 
1 5679 16.1%
 
2 3225 9.2%
 
3 1640 4.7%
 
4 969 2.8%
 
ValueCountFrequency (%) 
36 1 < 0.1%
 
33 1 < 0.1%
 
32 2 < 0.1%
 
30 2 < 0.1%
 
27 1 < 0.1%
 

Count_Related_Changes
Real number (ℝ≥0)

ZEROS
Distinct count5
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.01425812315
Minimum0
Maximum9
Zeros34732
Zeros (%)98.6%
Memory size275.2 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum9
Range9
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.1310709997
Coefficient of variation (CV)9.192724615
Kurtosis697.7481615
Mean0.01425812315
Median Absolute Deviation (MAD)0.02813071651
Skewness16.60123313
Sum502
Variance0.01717960696
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 9. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 34732 98.6%
 
1 458 1.3%
 
2 16 < 0.1%
 
3 1 < 0.1%
 
9 1 < 0.1%
 
ValueCountFrequency (%) 
0 34732 98.6%
 
1 458 1.3%
 
2 16 < 0.1%
 
3 1 < 0.1%
 
9 1 < 0.1%
 
ValueCountFrequency (%) 
9 1 < 0.1%
 
3 1 < 0.1%
 
2 16 < 0.1%
 
1 458 1.3%
 
0 34732 98.6%
 

Count_Related_Incidents
Real number (ℝ≥0)

SKEWED
ZEROS
Distinct count24
Unique (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.05086912065
Minimum0
Maximum63
Zeros34164
Zeros (%)97.0%
Memory size275.2 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum63
Range63
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.6697767861
Coefficient of variation (CV)13.16666727
Kurtosis3751.636387
Mean0.05086912065
Median Absolute Deviation (MAD)0.09872146319
Skewness50.43666887
Sum1791
Variance0.4486009431
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 4.5 12.5 25.5 63. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 34164 97.0%
 
1 902 2.6%
 
2 57 0.2%
 
3 19 0.1%
 
4 12 < 0.1%
 
6 8 < 0.1%
 
5 7 < 0.1%
 
8 5 < 0.1%
 
9 5 < 0.1%
 
11 4 < 0.1%
 
Other values (14) 25 0.1%
 
ValueCountFrequency (%) 
0 34164 97.0%
 
1 902 2.6%
 
2 57 0.2%
 
3 19 0.1%
 
4 12 < 0.1%
 
ValueCountFrequency (%) 
63 1 < 0.1%
 
54 1 < 0.1%
 
26 1 < 0.1%
 
25 1 < 0.1%
 
24 2 < 0.1%
 

Count_Related_Interactions
Real number (ℝ≥0)

SKEWED
Distinct count46
Unique (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.132981141
Minimum0
Maximum118
Zeros111
Zeros (%)0.3%
Memory size275.2 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile1
Q11
median1
Q31
95-th percentile2
Maximum118
Range118
Interquartile range (IQR)0

Descriptive statistics

Standard deviation1.453371827
Coefficient of variation (CV)1.282785542
Kurtosis2071.118001
Mean1.132981141
Median Absolute Deviation (MAD)0.2539718063
Skewness37.81452834
Sum39890
Variance2.112289667
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 4.5 7.5 23.5 44.5 118. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1 32675 92.8%
 
2 1941 5.5%
 
3 279 0.8%
 
0 111 0.3%
 
4 78 0.2%
 
5 24 0.1%
 
6 14 < 0.1%
 
7 10 < 0.1%
 
12 6 < 0.1%
 
8 6 < 0.1%
 
Other values (36) 64 0.2%
 
ValueCountFrequency (%) 
0 111 0.3%
 
1 32675 92.8%
 
2 1941 5.5%
 
3 279 0.8%
 
4 78 0.2%
 
ValueCountFrequency (%) 
118 1 < 0.1%
 
88 1 < 0.1%
 
74 1 < 0.1%
 
57 1 < 0.1%
 
45 2 < 0.1%
 

Handle_Time_Hours
Real number (ℝ≥0)

Distinct count24791
Unique (%)70.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean18.43136718
Minimum0
Maximum1275.791944
Zeros208
Zeros (%)0.6%
Memory size275.2 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile0.110277778
Q10.872222222
median3.515
Q314.17472223
95-th percentile69.30519444
Maximum1275.791944
Range1275.791944
Interquartile range (IQR)13.3025

Descriptive statistics

Standard deviation60.990057
Coefficient of variation (CV)3.309035972
Kurtosis132.1412276
Mean18.43136718
Median Absolute Deviation (MAD)22.94645598
Skewness9.969159617
Sum648931.5756
Variance3719.787052
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[0.00000000e+00 9.72222000e-04 5.69444450e-03 2.70833330e-02 4.34722220e-02 ... 1.79156250e+02 2.49430000e+02 3.81836389e+02 7.08183889e+02 1.27579194e+03], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 208 0.6%
 
0.021388889 18 0.1%
 
0.011666667 14 < 0.1%
 
0.014722222 14 < 0.1%
 
0.015833333 13 < 0.1%
 
0.015555556 13 < 0.1%
 
0.0075 12 < 0.1%
 
0.018333333 12 < 0.1%
 
0.020277778 12 < 0.1%
 
0.009722222 12 < 0.1%
 
Other values (24781) 34880 99.1%
 
ValueCountFrequency (%) 
0 208 0.6%
 
0.001944444 1 < 0.1%
 
0.002222222 2 < 0.1%
 
0.003055556 2 < 0.1%
 
0.003333333 1 < 0.1%
 
ValueCountFrequency (%) 
1275.791944 1 < 0.1%
 
1250.033056 1 < 0.1%
 
1205.674722 1 < 0.1%
 
1203.563333 1 < 0.1%
 
1168.831111 1 < 0.1%
 

KM_number
Categorical

HIGH CARDINALITY
Distinct count1542
Unique (%)4.4%
Missing0
Missing (%)0.0%
Memory size275.2 KiB
KM0001106
 
1006
KM0000940
 
813
KM0002043
 
770
KM0001444
 
746
KM0001447
 
529
Other values (1537)
31344
ValueCountFrequency (%) 
KM0001106 1006 2.9%
 
KM0000940 813 2.3%
 
KM0002043 770 2.2%
 
KM0001444 746 2.1%
 
KM0001447 529 1.5%
 
KM0000075 479 1.4%
 
KM0001736 454 1.3%
 
KM0000938 427 1.2%
 
KM0000741 397 1.1%
 
KM0001363 367 1.0%
 
Other values (1532) 29220 83.0%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length9
Mean length9
Min length9
Scatter
Distinct count35035
Unique (%)99.5%
Missing0
Missing (%)0.0%
Memory size275.2 KiB
Minimum2013-10-01 07:33:21
Maximum2014-03-31 17:24:49
Mini histogram
Histogram
Histogram
Distinct count7
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size275.2 KiB
Monday
7990
Tuesday
7661
Thursday
7046
Wednesday
6407
Friday
5814
Other values (2)
 
290
ValueCountFrequency (%) 
Monday 7990 22.7%
 
Tuesday 7661 21.8%
 
Thursday 7046 20.0%
 
Wednesday 6407 18.2%
 
Friday 5814 16.5%
 
Saturday 206 0.6%
 
Sunday 84 0.2%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length9
Mean length7.175471484
Min length6
Scatter

Open_Time_HourOfDay
Real number (ℝ≥0)

Distinct count24
Unique (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean12.05907748
Minimum0
Maximum23
Zeros48
Zeros (%)0.1%
Memory size275.2 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile8
Q110
median12
Q314
95-th percentile16
Maximum23
Range23
Interquartile range (IQR)4

Descriptive statistics

Standard deviation2.789502693
Coefficient of variation (CV)0.231319742
Kurtosis0.001756534247
Mean12.05907748
Median Absolute Deviation (MAD)2.347338821
Skewness-0.001930680395
Sum424576
Variance7.781325272
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 4.5 6.5 ... 16.5 17.5 18.5 19.5 23. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
10 4604 13.1%
 
11 4581 13.0%
 
9 4490 12.8%
 
14 3900 11.1%
 
15 3835 10.9%
 
13 3295 9.4%
 
12 3265 9.3%
 
16 3141 8.9%
 
8 2229 6.3%
 
17 901 2.6%
 
Other values (14) 967 2.7%
 
ValueCountFrequency (%) 
0 48 0.1%
 
1 43 0.1%
 
2 20 0.1%
 
3 17 < 0.1%
 
4 22 0.1%
 
ValueCountFrequency (%) 
23 21 0.1%
 
22 18 0.1%
 
21 30 0.1%
 
20 36 0.1%
 
19 90 0.3%
 

OpenShift
Categorical

Distinct count3
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size34.6 KiB
Day
31111
Night
 
2840
Evening
 
1257
ValueCountFrequency (%) 
Day 31111 88.4%
 
Night 2840 8.1%
 
Evening 1257 3.6%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length7
Mean length3.304135424
Min length3
Scatter

Priority
Categorical

Distinct count5
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size34.7 KiB
4 Low
21120
5 Very Low
7962
3 Medium
5721
2 High
 
402
1 Very High
 
3
ValueCountFrequency (%) 
4 Low 21120 60.0%
 
5 Very Low 7962 22.6%
 
3 Medium 5721 16.2%
 
2 High 402 1.1%
 
1 Very High 3 < 0.1%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length11
Mean length6.630112474
Min length5
Scatter
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size275.2 KiB
0
33782
1
 
1426
ValueCountFrequency (%) 
0 33782 95.9%
 
1 1426 4.1%
 
Distinct count35069
Unique (%)99.6%
Missing0
Missing (%)0.0%
Memory size275.2 KiB
Minimum2013-10-01 08:29:16
Maximum2014-03-31 22:47:29
Mini histogram
Histogram
Histogram

Resolved_Time_DayOfWeek
Categorical

HIGH CORRELATION
HIGH CORRELATION
Distinct count7
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size275.2 KiB
Tuesday
7588
Monday
7291
Thursday
6945
Wednesday
6660
Friday
6574
Other values (2)
 
150
ValueCountFrequency (%) 
Tuesday 7588 21.6%
 
Monday 7291 20.7%
 
Thursday 6945 19.7%
 
Wednesday 6660 18.9%
 
Friday 6574 18.7%
 
Saturday 92 0.3%
 
Sunday 58 0.2%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length9
Mean length7.182742559
Min length6
Scatter

Resolved_Time_HourOfDay
Real number (ℝ≥0)

HIGH CORRELATION
Distinct count23
Unique (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean12.32910134
Minimum0
Maximum23
Zeros8
Zeros (%)< 0.1%
Memory size275.2 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile8
Q110
median12
Q315
95-th percentile16
Maximum23
Range23
Interquartile range (IQR)5

Descriptive statistics

Standard deviation2.826989242
Coefficient of variation (CV)0.2292940226
Kurtosis-0.6036000994
Mean12.32910134
Median Absolute Deviation (MAD)2.413373014
Skewness-0.01303194582
Sum434083
Variance7.991868173
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 4.5 5.5 6.5 ... 16.5 17.5 18.5 21.5 23. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
14 4408 12.5%
 
15 4364 12.4%
 
11 3962 11.3%
 
13 3797 10.8%
 
10 3786 10.8%
 
16 3442 9.8%
 
9 3227 9.2%
 
12 3098 8.8%
 
8 2610 7.4%
 
17 1151 3.3%
 
Other values (13) 1363 3.9%
 
ValueCountFrequency (%) 
0 8 < 0.1%
 
1 5 < 0.1%
 
3 2 < 0.1%
 
4 1 < 0.1%
 
5 15 < 0.1%
 
ValueCountFrequency (%) 
23 7 < 0.1%
 
22 34 0.1%
 
21 86 0.2%
 
20 52 0.1%
 
19 64 0.2%
 

ResolvedShift
Categorical

HIGH CORRELATION
Distinct count3
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size34.6 KiB
Day
30084
Night
 
3566
Evening
 
1558
ValueCountFrequency (%) 
Day 30084 85.4%
 
Night 3566 10.1%
 
Evening 1558 4.4%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length7
Mean length3.379572824
Min length3
Scatter

Service_Component_WBS_aff
Categorical

HIGH CARDINALITY
Distinct count260
Unique (%)0.7%
Missing0
Missing (%)0.0%
Memory size275.2 KiB
WBS000073
12669
WBS000091
 
2335
WBS000263
 
1367
WBS000318
 
1075
WBS000152
 
1022
Other values (255)
16740
ValueCountFrequency (%) 
WBS000073 12669 36.0%
 
WBS000091 2335 6.6%
 
WBS000263 1367 3.9%
 
WBS000318 1075 3.1%
 
WBS000152 1022 2.9%
 
WBS000223 760 2.2%
 
WBS000092 672 1.9%
 
WBS000128 651 1.8%
 
WBS000089 551 1.6%
 
WBS000292 532 1.5%
 
Other values (250) 13574 38.6%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length9
Mean length9
Min length9
Scatter

ServiceComp_WBS_CBy
Categorical

HIGH CARDINALITY
Distinct count263
Unique (%)0.7%
Missing0
Missing (%)0.0%
Memory size275.2 KiB
WBS000073
12582
WBS000091
 
2289
#N/B
 
1807
WBS000263
 
1252
WBS000318
 
1098
Other values (258)
16180
ValueCountFrequency (%) 
WBS000073 12582 35.7%
 
WBS000091 2289 6.5%
 
#N/B 1807 5.1%
 
WBS000263 1252 3.6%
 
WBS000318 1098 3.1%
 
WBS000152 964 2.7%
 
WBS000128 778 2.2%
 
WBS000223 764 2.2%
 
WBS000092 597 1.7%
 
WBS000089 576 1.6%
 
Other values (253) 12501 35.5%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length9
Mean length8.743382186
Min length4
Scatter

SLAFail
Boolean

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size275.2 KiB
0
24690
1
10518
ValueCountFrequency (%) 
0 24690 70.1%
 
1 10518 29.9%
 

TimeToResolve_Minutes
Real number (ℝ≥0)

Distinct count27916
Unique (%)79.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5301.754552
Minimum0.2833333333
Maximum252400.5
Zeros0
Zeros (%)0.0%
Memory size275.2 KiB
Mini histogram

Quantile statistics

Minimum0.2833333333
5-th percentile11.61666667
Q172.55416667
median980.475
Q34497.558333
95-th percentile21588.1525
Maximum252400.5
Range252400.2167
Interquartile range (IQR)4425.004167

Descriptive statistics

Standard deviation14904.14125
Coefficient of variation (CV)2.811171491
Kurtosis78.9751513
Mean5301.754552
Median Absolute Deviation (MAD)6744.973642
Skewness7.602235849
Sum186664174.3
Variance222133426.5
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[2.83333333e-01 6.41666667e-01 2.02500000e+00 4.84166667e+00 2.63583333e+01 ... 8.22603917e+04 1.22118317e+05 1.22611342e+05 2.11693550e+05 2.52400500e+05], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
8.366666667 10 < 0.1%
 
7.266666667 9 < 0.1%
 
1.35 9 < 0.1%
 
1.183333333 9 < 0.1%
 
4.25 9 < 0.1%
 
1.233333333 9 < 0.1%
 
1.166666667 9 < 0.1%
 
1.5 8 < 0.1%
 
14.31666667 8 < 0.1%
 
17.28333333 8 < 0.1%
 
Other values (27906) 35120 99.8%
 
ValueCountFrequency (%) 
0.2833333333 1 < 0.1%
 
0.4 1 < 0.1%
 
0.4666666667 1 < 0.1%
 
0.4833333333 2 < 0.1%
 
0.55 1 < 0.1%
 
ValueCountFrequency (%) 
252400.5 1 < 0.1%
 
250877.4667 1 < 0.1%
 
244831.95 1 < 0.1%
 
240425.25 1 < 0.1%
 
240309.7167 1 < 0.1%
 

Correlations

Missing values

Sample

First rows

CI_Name_affCI_Name_CByCI_TypeSubType_affCI_TypeSubType_CByClose_TimeClose_Time_DayOfWeekClose_Time_HourOfDayCloseShiftClosure_CodeCount_ReassignmentsCount_Related_ChangesCount_Related_IncidentsCount_Related_InteractionsHandle_Time_HoursKM_numberOpen_TimeOpen_Time_DayOfWeekOpen_Time_HourOfDayOpenShiftPriorityReopenedFlagResolved_TimeResolved_Time_DayOfWeekResolved_Time_HourOfDayResolvedShiftService_Component_WBS_affServiceComp_WBS_CBySLAFailTimeToResolve_Minutes
0APP000005APP000005application-Citrixapplication-Citrix2013-10-01 08:37:28Tuesday8NightSoftware0.00.00.01.01.068611KM00010602013-10-01 07:33:21Tuesday7Night4 Low02013-10-01 08:36:09Tuesday8NightWBS000292WBS000292062.800000
1DSK000457DSK000457computer-Desktopcomputer-Desktop2013-10-07 11:52:00Monday11DayHardware2.00.00.01.045.556111KM00014462013-10-01 08:18:38Tuesday8Night5 Very Low02013-10-07 11:51:53Monday11DayWBS000187WBS00018718853.250000
2SBA000263#N/Bapplication-Server Based Application#N/B-#N/B2013-10-07 16:55:38Monday16DayOther12.00.00.01.050.324722KM00006442013-10-01 08:36:09Tuesday8Night5 Very Low02013-10-07 16:55:08Monday16DayWBS000072#N/B19138.983333
3SBA000154SBA000154application-Server Based Applicationapplication-Server Based Application2013-10-01 15:39:51Tuesday15DayOther1.00.00.01.07.003889KM00012912013-10-01 08:39:37Tuesday8Night5 Very Low02013-10-01 15:39:47Tuesday15DayWBS000027WBS0000270420.166667
4LAP000019KYB000001computer-Laptophardware-Keyboard2013-10-02 11:30:19Wednesday11DayOther0.00.00.01.00.020278KM00003152013-10-01 08:40:00Tuesday8Night5 Very Low02013-10-02 11:30:13Wednesday11DayWBS000091WBS00009101610.216667
5SBA000025SBA000025application-Server Based Applicationapplication-Server Based Application2013-10-01 11:55:19Tuesday11DayUnknown1.00.00.03.02.974167KM00000292013-10-01 08:56:52Tuesday8Night3 Medium02013-10-01 11:55:17Tuesday11DayWBS000006WBS0000060178.416667
6WBA000058WBA000058application-Web Based Applicationapplication-Web Based Application2013-10-01 10:02:06Tuesday10DayOther0.00.00.01.00.605833KM00012452013-10-01 09:25:45Tuesday9Day4 Low02013-10-01 10:02:04Tuesday10DayWBS000073WBS000073036.316667
7CBD000615SBA000154computer-Banking Deviceapplication-Server Based Application2013-10-01 22:13:50Tuesday22EveningOther1.00.00.01.08.483611KM00002682013-10-01 09:30:59Tuesday9Day3 Medium02013-10-01 22:13:47Tuesday22EveningWBS000146WBS0000270762.800000
8SBA000338SBA000338application-Server Based Applicationapplication-Server Based Application2013-10-01 10:12:16Tuesday10DayOther1.00.00.01.00.515556KM00003272013-10-01 09:41:20Tuesday9Day4 Low02013-10-01 10:12:09Tuesday10DayWBS000169WBS000169030.816667
9SBA000698SBA000698application-Server Based Applicationapplication-Server Based Application2013-10-02 15:50:21Wednesday15DaySoftware3.00.00.01.017.735556KM00015262013-10-01 08:36:13Tuesday8Night4 Low02013-10-02 15:50:18Wednesday15DayWBS000090WBS00009001874.083333

Last rows

CI_Name_affCI_Name_CByCI_TypeSubType_affCI_TypeSubType_CByClose_TimeClose_Time_DayOfWeekClose_Time_HourOfDayCloseShiftClosure_CodeCount_ReassignmentsCount_Related_ChangesCount_Related_IncidentsCount_Related_InteractionsHandle_Time_HoursKM_numberOpen_TimeOpen_Time_DayOfWeekOpen_Time_HourOfDayOpenShiftPriorityReopenedFlagResolved_TimeResolved_Time_DayOfWeekResolved_Time_HourOfDayResolvedShiftService_Component_WBS_affServiceComp_WBS_CBySLAFailTimeToResolve_Minutes
35198SBA000604SBA000604application-Server Based Applicationapplication-Server Based Application2014-03-31 16:32:33Monday16DayNo error - works as designed1.00.00.01.01.468333KM00005832014-03-31 15:04:27Monday15Day5 Very Low02014-03-31 16:31:53Monday16DayWBS000067WBS000067087.433333
35199COM000003SBA000729computer-Omgevingapplication-Server Based Application2014-03-31 17:21:59Monday17EveningOther1.00.00.01.02.138611KM00009172014-03-31 15:13:40Monday15Day4 Low02014-03-31 17:21:54Monday17EveningWBS000335WBS0001010128.233333
35200WBA000144WBA000144application-Web Based Applicationapplication-Web Based Application2014-03-31 17:20:06Monday17EveningSoftware3.00.00.02.01.381389KM00008362014-03-31 15:55:07Monday15Day5 Very Low12014-03-31 17:20:03Monday17EveningWBS000318WBS000318084.933333
35201WBA000144WBA000144application-Web Based Applicationapplication-Web Based Application2014-03-31 19:34:22Monday19EveningUser error0.00.00.01.01.343056KM00008462014-03-31 16:39:25Monday16Day4 Low02014-03-31 19:34:19Monday19EveningWBS000318WBS0003180174.900000
35202SBA000462SBA000462application-Server Based Applicationapplication-Server Based Application2014-03-31 16:35:28Monday16DayOther0.00.00.01.00.459444KM00013642014-03-31 16:07:54Monday16Day4 Low02014-03-31 16:35:25Monday16DayWBS000073WBS000073027.516667
35203SBA000464SBA000464application-Server Based Applicationapplication-Server Based Application2014-03-31 16:29:24Monday16DayOther0.00.00.01.00.095000KM00013142014-03-31 16:23:42Monday16Day4 Low02014-03-31 16:29:21Monday16DayWBS000073WBS00007305.650000
35204SBA000461SBA000461application-Server Based Applicationapplication-Server Based Application2014-03-31 15:29:27Monday15DayUser error0.00.00.01.00.428333KM00023602014-03-31 15:03:45Monday15Day4 Low02014-03-31 15:29:19Monday15DayWBS000073WBS000073025.566667
35205LAP000019LAP000019computer-Laptopcomputer-Laptop2014-03-31 15:32:40Monday15DayHardware0.00.00.01.00.071667KM00003152014-03-31 15:28:22Monday15Day5 Very Low02014-03-31 15:32:37Monday15DayWBS000091WBS00009104.250000
35206WBA000058WBA000058application-Web Based Applicationapplication-Web Based Application2014-03-31 15:42:36Monday15DaySoftware0.00.00.01.00.116944KM00012872014-03-31 15:35:35Monday15Day4 Low02014-03-31 15:42:34Monday15DayWBS000073WBS00007306.983333
35207DCE000077DCE000077hardware-DataCenterEquipmenthardware-DataCenterEquipment2014-03-31 22:47:32Monday22EveningHardware0.00.00.01.00.586389KM00001822014-03-31 17:24:49Monday17Evening3 Medium02014-03-31 22:47:29Monday22EveningWBS000267WBS0002670322.666667